How to insert page break in Excel worksheet

您所在的位置:网站首页 how to change page breaks in excel How to insert page break in Excel worksheet

How to insert page break in Excel worksheet

2023-04-06 17:58| 来源: 网络整理| 查看: 265

Microsoft Excel is a great tool that helps users achieve many functions. After working on Excel, you may want to print your work. This is where Excel page breaks come in.Excel Mastermind

Page breaks help to break an Excel worksheet into separate pages 9and numbers) for printing. By default, Microsoft Excel inserts automatic page breaks based on the page settings, paper size, margin, scale options, and any other manual page settings that you insert.聽

However, you have your preference for printing a worksheet, such as an exact number of pages or items on a given page. To achieve this, you can adjust page breaks in the worksheet because Excel allows you to insert page breaks in worksheets before printing.

Delete Page Breaks in Excel

In this article, you鈥檒l learn how to insert page breaks in Excel manually. You'll also learn where to find the Page Break Preview, hide, and show the marking lines and how you can adjust, remove, hide, or show the page breaks in the worksheet before printing.聽

Let鈥檚 go!

Page Break Previews聽

By default, you can work with Excel page breaks in the Normal view. However, we recommend that you use the Page Break Preview view to adjust page breaks. This way, you鈥檒l see how other changes you make (such as formatting and page orientation changes) affect the automatic Excel page breaks. For instance, you鈥檒l see how a change in the row height and column width affects the automatic placement of page breaks.聽

When you use Page Break Preview:

The dashed lines are automatically added Excel page breaks. The Solid lines are manually added page Excel breaks.page breaks 聽 Insert a page break in Excel

You Insert a page break in Excel, purposely for printing, to specify where the new page will begin in the printed copy.聽

Tip: You can insert page break by two methods

Using the page break function on the View tab Using the right-click.

To insert a page break:

Click the Excel Worksheet that you want to print. Navigate to the View tab click > the locate and click Page Break Preview.Page Break Preview Tip: You can also see the automatic page breaks through the Page Break Preview Button on the Excel status bar.Page breaks preview button You can see the location of the page breaks on your worksheet (appearing a the dotted lines).visible page breaks To insert a horizontal page break: Select the row where the marking line will appear. Insert Horizontal page breaks On the Page Layout tab, > click Breaks > the Click Insert Page BreakInsert Horizontal Page breaks Excel will display a solid line (denting manual page break) to indicate where the new page begins. The dashed lines are Excel鈥檚 inserted page breaks automatically.Page Breaks Do the same to insert vertical page breaks.聽

Note:聽

You can also insert page breaks by right-clicking the row or column below or to the right of where you want to insert the page break, and then locating and clicking Insert Page Break.聽

Move a page break in Excel.聽

You can move a page break in Excel by dragging page breaks to another location in a Worksheet.聽

First, ensure that you enable the cell drag-and-drop feature in Excel. Keeping this feature disabled may deter you from being able to move any page breaks.聽

To move page breaks:

Verify that drag-and-drop聽is enabled, do the following:聽 Click the File tab > Options.聽 Check the Advanced category, under Editing options,聽 Select Enable fill handle and cell drag-and-drop聽 Check the box > then click OK. Click the worksheet that you want to modify.聽 Got to the View tab > click Page Break Preview (or click Page break preview through the status bar)Page break preview Drag the page break to a new location, to move a page break.

Note: Moving the automatic page break changes process 9and the page break) to a manual page break.聽

Remove page breaks in Excel (delete page break)

To remove (delete) a page break:

Note: you cannot delete an automatic page break in Excel.

Select the excel worksheet that you want to modify.聽 Select the Page Break Preview on the View tab or on the status bar.Page break preview Select the page break you want to remove For vertical page break: select the column to the right of the page break you want to do delete.聽 For horizontal page break: select the row below the page break you want to delete.聽 Go to the Page Layout tab > select Breaks > then click Remove Page Break Remove page breaks

Note:聽

If you want to remove all page breaks, both vertical page breaks and horizontal breaks:聽 Click Page Layout > Breaks > Remove All Page Break. You can remove a page break by dragging it outside of the page break preview area (to the left past the row headers, or up past the column headers).聽 To remove a vertical break through the right-click: Select the column to the right of the line > Right-click > then select Remove Page Break. To remove a horizontal page break through the right-click; 聽Select the row below the line that you want to delete > Right-click > select Remove Page Break聽 聽 Remove all manually-inserted page breaks

Note: removing all manually-inserted page breaks resets the worksheet to display only the automatic page breaks.聽

Click the Excel worksheet that you want to modify. Go to the View tab > click Page Break Preview.

Note: You can also click Page Break Preview on the status bar.聽

Got to the Page Layout tab > click Breaks.聽 Click Reset All Page Breaks.聽

Note: You can also do this by right-clicking any sell on the worksheet you鈥檙e modifying, and then clicking Reset All Page Breaks.

Return Excel to Normal View

You may want to return Excel to Normal view after finishing printing with the page breaks,聽

Got to the View tab click Normal (first item on the left of View tab). You can also click Normal on the status bar.聽 To hide the page breaks after returning the Excel view to Normal, close and reopen the workbook, without saving it.聽 聽 Display or hide page breaks in Normal view

Click the File tab > Options.聽 Go to the Advanced category, under Display options for this worksheet. Select or clear the Show page breaks check box to turn page breaks on or off聽 聽 Wrapping Up聽

That's it.聽

We believe you now know how to use the Excel page break option. we鈥檝e tried to cover all its options and now you can insert, remove, move, show, and hide page breaks to adjust them before printing.聽

Make Excel your greatest tool. Be happy and excel in Excel!

If you鈥檙e looking for more guides or want to read more Excel, and tech-related articles, consider subscribing to our newsletter where we regularly publish tutorials, news articles, and guides.

Recommended Reads聽

13 Excel Tips and Tricks to Make You Into a Pro Top 51 Excel Templates to Boost Your Productivity How to use the NPER Function in Excel The Most Useful Excel Keyboard Shortcuts How to Calculate Break-Even Analysis in Excel The Z-Score in Excel How Do I Insert or Delete a Page Break in Word?


【本文地址】


今日新闻


推荐新闻


CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3